Card authorization account information and cash account information is kept in the following iMIS tables.
Card authorization accounts using the VeriSign gateway
The following columns in the CCAuthAcct table are used for each VeriSign card authorization account:
Column |
Data Type |
Description |
---|---|---|
CCAuthAcctCode |
varchar (20) |
The code for the card authorization account |
CCAuthAcctDescription |
varchar (255) |
Description associated with an account code |
CCAuthMode |
tinyint |
Authorization mode: 0 (manual), 1 (immediate), or 3 (deferred) |
CCAuthAdminEmail |
varchar (255) |
E-mail address of the system administrator responsible for setting up the accounts |
CCAuthUrl |
varchar (255) |
URL of the test or live site |
CCAuthGateway |
varchar (255) |
Gateway interface through which card authorization occurs (Verisign) |
CCAuthPort |
int |
Port address used for VeriSign transaction processing |
CCAuthUser |
varchar (255) |
Username created during setup process |
CCAuthPassword |
varchar (255) |
Password created during VeriSign sign-up process |
CCAuthVerisignPartner |
varchar (255) |
Partner name supplied by VeriSign |
CCAuthVerisignVendor |
varchar (255) |
Vendor name supplied by VeriSign |
CCAuthTimeout |
int |
Timeout period supplied by VeriSign |
CCAuthVerisignProxyServer |
varchar (255) |
VeriSign proxy server supplied by network administrator |
CCAuthVerisignProxyPort |
varchar (255) |
VeriSign proxy port supplied by network administrator |
CCAuthVerisignProxyUser |
varchar (255) |
VeriSign proxy user ID supplied by network administrator |
CCAuthVerisignProxyPassword |
varchar (255) |
VeriSign proxy password supplied by network administrator |
CCAuthSaveCscBeforeAuth |
tinyint |
Handling of CSC value for deferred authorization: 0 (do not save CSC in iMIS) or 1 (save encrypted CSC in iMIS then delete after successful authorization) |
Card authorization accounts using the QSI gateway
The following columns in the CCAuthAcct table are used for each QSI card authorization account:
Column |
Data Type |
Description |
---|---|---|
CCAuthAcctCode |
varchar (20) |
The code for the card authorization account |
CCAuthAcctDescription |
varchar (255) |
Description associated with an account code |
CCAuthMode |
tinyint |
Authorization mode: 0 (manual), 1 (immediate), or 3 (deferred) |
CCAuthAdminEmail |
varchar (255) |
E-mail address of the system administrator responsible for setting up the accounts |
CCAuthGateway |
varchar (255) |
Gateway interface through which card authorization occurs (QSI) |
CCAuthUser |
varchar (255) |
QSI Merchant ID created during setup process |
CCAuthVerisignPartner |
varchar (255) |
QSI Merchant Administration login (username) obtained from QSI/Dialect during setup process |
CCAuthPassword |
varchar (255) |
QSI Merchant Administration login (username) password obtained from QSI/Dialect during setup process |
CCAuthSaveCscBeforeAuth |
tinyint |
Handling of CSC value for deferred authorization: 0 (do not save CSC in iMIS) or 1 (save encrypted CSC in iMIS then delete after successful authorization) |
Card authorization accounts using the Other gateway
The following columns in the CCAuthAcct table are used for each Other card authorization account:
Column |
Data Type |
Description |
---|---|---|
CCAuthAcctCode |
varchar (20) |
The code for the card authorization account |
CCAuthAcctDescription |
varchar (255) |
Description associated with an account code |
CCAuthMode |
tinyint |
Authorization mode: 0 (manual), 1 (immediate), or 3 (deferred) |
CCAuthGateway |
varchar (255) |
Gateway interface through which card authorization occurs (Other) |
CCAuthSaveCscBeforeAuth |
tinyint |
Handling of CSC value for deferred authorization: 0 (do not save CSC in iMIS) or 1 (save encrypted CSC in iMIS) |
Cash accounts for credit/debit cards
The following columns in the Cash_Accounts table are used for each credit/debit card cash account:
Column |
Data Type |
Description |
---|---|---|
CCAuthAcctCode |
varchar (20) |
The code for the card authorization account |
CSC_REQUIRED_WEB |
bit |
Indicates whether the CSC value is required in e-Series: 0 (not required) or 1 (required) |
CSC_REQUIRED_CS |
bit |
Indicates whether the CSC value is required in iMIS: 0 (not required) or 1 (required) |
ISSUE_NO_FLAG |
tinyint |
Indicates whether the Issue Number field should be displayed in iMIS payment entry windows: 0 (not displayed) or 1 (displayed) |
ISSUE_DATE_FLAG |
tinyint |
Indicates whether the Issue Date field should be displayed in iMIS payment entry windows: 0 (not displayed) or 1 (displayed) |
10.6 Production Release. Updated 3/20/2006 3:45:05 PM
© 2009 by Advanced Solutions International, Inc.
All rights reserved.